﻿CREATE TABLE [dbo].[User_Role] (
    [UserID] INT NOT NULL,
    [RoleID] INT NOT NULL,
    CONSTRAINT [PK_User_Role_1] PRIMARY KEY CLUSTERED ([UserID] ASC, [RoleID] ASC),
    CONSTRAINT [FK_User_Role_Role1] FOREIGN KEY ([RoleID]) REFERENCES [dbo].[Role] ([RoleID]),
    CONSTRAINT [FK_User_Role_User1] FOREIGN KEY ([UserID]) REFERENCES [dbo].[User] ([UserID])
);

